Step-by-Step Guide

For information about the current log file size, its maximum size, and the autogrowth option for the file, you can also use the size, max_size, and growth columns for that log file in sys.database_files.

如需目前記錄檔大小、大小上限以及檔案自動成長選項的相關資訊，您也可以在 max_size 中使用記錄檔的 size 、 max_size 和 growth 欄位。

SQL Server log (LDF file) is too big - what causes log file too large, how to detect it, how to fix it and how to shrink it

In the first method you have seen how to check the size of the log file using the sys.database_files view and in the second learned about checking the size of all the log files using sys.master.files view.

Learn about transaction log growth and how to monitor growth to keep the file size in check.

In this part we look at general rules of how large a SQL Server transaction log should be compared to your database file sizes.

Ideally, you should size your transaction log so it will never need to grow, but in the real world, it is hard to predict how big a transaction log needs to be. Most of the time, the transaction log for a new database will be too small or too big. When it